alter table InvShortageOrder
   add
    FSendOrderID  varchar(50) NOT NULL,
    FSendOrderNumber  varchar(50) NOT NULL,
	FCustomerId varchar(50) NOT NULL,
	FStatus varchar(50) NOT NULL
go

alter table InvShortageOrderDetail
   add
    FReturnNumber bigint
go



alter table InvShortageOrder
   add constraint FK_INVSHORT_REFERENCE_INVSEND_FID foreign key (FSendOrderID)
      references InvSendOrder (FId)
go

alter table InvShortageOrder
   add constraint FK_INVSHORT_REFERENCE_CUSTOMER_FID foreign key (FCustomerId)
      references BdCustomer (FId)
go


alter table InvShortageOrder
   add constraint FK_INVSHORT_REFERENCE_CATERORY_FSTATUS foreign key (FStatus)
      references BdCategory (FId)
go